package com.sto.stoapp.db.constant;

/**
 * 业务员接口
 * 
 * @author mgf
 * 
 */
public interface StoSalesConstant extends StoBaseConstant {

	public static final String BACKUP1 = "backup1";

	/**
	 *  收件员编号长度
	 */
	public final int RECEIVE_CODE_LENGTH = 4;
	
	/**
	 *  收件员编号最大长度10
	 */
	public final int RECEIVE_CODE_MAX_LENGTH = 10;
	/**
	 * 员工编号
	 */
	public static final String SALES_NUMBER = "sales_number";

	/**
	 * 员工姓名
	 */
	public static final String SALES_NAME = "sales_name";

	/**
	 * 员工数据库表名
	 */
	public static final String SALES_TABLE = "sales_table";

	/**
	 * 创建员工数据库表
	 */
	public static final String CREATE_SALES_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ SALES_TABLE
			+ "("
			+ "id  text PRIMARY KEY "
			+ ","
			+ VERSION
			+ " text "
			+ ","
			+ BACKUP1
			+ " text "
			+ ","
			+ SALES_NUMBER
			+ " varchar(12)"
			+ ","
			+ SALES_NAME
			+ " char(20)"
			+ ","
			+STATUS
			+" text "
			+","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";

	/**
	 * 删除员工数据库表
	 */
	public static final String DROP_SALES_TABLE = "drop table if exists "
			+ SALES_TABLE;
}
